Dataset statistics
| Number of variables | 49 |
|---|---|
| Number of observations | 9224587 |
| Missing cells | 44304565 |
| Missing cells (%) | 9.8% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 3.4 GiB |
| Average record size in memory | 400.0 B |
Variable types
| Numeric | 15 |
|---|---|
| Categorical | 29 |
| Boolean | 5 |
ORIGIN_AIRPORT_CODE has a high cardinality: 657 distinct values | High cardinality |
DESTINATION_AIRPORT_CODE has a high cardinality: 679 distinct values | High cardinality |
FLIGHT_DATE_LOCAL has a high cardinality: 727 distinct values | High cardinality |
TIME_DEPARTURE_LOCAL_TIME has a high cardinality: 1051 distinct values | High cardinality |
AIRCRAFT_TYPE has a high cardinality: 65 distinct values | High cardinality |
FARE_BASIS has a high cardinality: 33211 distinct values | High cardinality |
UPGRADE_SALES_DATE has a high cardinality: 481 distinct values | High cardinality |
FORM_OF_PAYMENT has a high cardinality: 79 distinct values | High cardinality |
LOYAL_CUSTOMER_DATE_OF_BIRTH has a high cardinality: 24920 distinct values | High cardinality |
LOYAL_CUSTOMER_REGISTERED_DATE has a high cardinality: 8930 distinct values | High cardinality |
SALES_DATE has a high cardinality: 365 distinct values | High cardinality |
INTINERARY has a high cardinality: 55794 distinct values | High cardinality |
BOOKING_ORIGIN_AIRPORT has a high cardinality: 145 distinct values | High cardinality |
BOOKING_ORIGIN_COUNTRY_CODE has a high cardinality: 51 distinct values | High cardinality |
BOOKING_DEPARTURE_TIME_UTC has a high cardinality: 83698 distinct values | High cardinality |
BOOKING_DESTINATION_AIRPORT has a high cardinality: 147 distinct values | High cardinality |
BOOKING_ARRIVAL_TIME_UTC has a high cardinality: 86418 distinct values | High cardinality |
MARKETING_CARRIER is highly correlated with OPERATIONAL_CARRIER | High correlation |
OPERATIONAL_CARRIER is highly correlated with MARKETING_CARRIER | High correlation |
STAY_LENGTH_D is highly correlated with SEGMENTS | High correlation |
FLIGHT_COUPONS is highly correlated with PAX_N | High correlation |
SEGMENTS is highly correlated with STAY_LENGTH_D | High correlation |
PAX_N is highly correlated with FLIGHT_COUPONS | High correlation |
MARKETING_CARRIER is highly correlated with OPERATIONAL_CARRIER | High correlation |
OPERATIONAL_CARRIER is highly correlated with MARKETING_CARRIER | High correlation |
STAY_LENGTH_D is highly correlated with SEGMENTS | High correlation |
FLIGHT_COUPONS is highly correlated with PAX_N | High correlation |
SEGMENTS is highly correlated with STAY_LENGTH_D | High correlation |
PAX_N is highly correlated with FLIGHT_COUPONS | High correlation |
MARKETING_CARRIER is highly correlated with OPERATIONAL_CARRIER | High correlation |
OPERATIONAL_CARRIER is highly correlated with MARKETING_CARRIER | High correlation |
STAY_LENGTH_D is highly correlated with SEGMENTS | High correlation |
FLIGHT_COUPONS is highly correlated with PAX_N | High correlation |
SEGMENTS is highly correlated with STAY_LENGTH_D | High correlation |
PAX_N is highly correlated with FLIGHT_COUPONS | High correlation |
UPGRADE_TYPE is highly correlated with BOOKING_DOMESTIC_FLAG and 1 other fields | High correlation |
BOOKING_DOMESTIC_FLAG is highly correlated with UPGRADE_TYPE | High correlation |
FLIGHT_RANGE is highly correlated with AIRCRAFT_TYPE and 1 other fields | High correlation |
BOOKING_ORIGIN_COUNTRY_CODE is highly correlated with BOOKING_LONG_HOUL_FLAG | High correlation |
AIRCRAFT_TYPE is highly correlated with FLIGHT_RANGE and 1 other fields | High correlation |
BOOKED_CLASS is highly correlated with BOOKED_CABIN | High correlation |
CURRENCY is highly correlated with BOOKING_LONG_HOUL_FLAG | High correlation |
VAB is highly correlated with BOOKING_LONG_HOUL_FLAG | High correlation |
BOOKING_LONG_HOUL_FLAG is highly correlated with FLIGHT_RANGE and 5 other fields | High correlation |
UPGRADED_FLAG is highly correlated with UPGRADE_TYPE | High correlation |
BOOKED_CABIN is highly correlated with BOOKED_CLASS | High correlation |
BOOKING_DESTINATION_COUNTRY_CODE is highly correlated with BOOKING_LONG_HOUL_FLAG | High correlation |
FLIGHT_DISTANCE is highly correlated with FLIGHT_RANGE and 7 other fields | High correlation |
FLIGHT_RANGE is highly correlated with FLIGHT_DISTANCE and 5 other fields | High correlation |
MARKETING_CARRIER is highly correlated with OPERATIONAL_CARRIER and 1 other fields | High correlation |
OPERATIONAL_CARRIER is highly correlated with FLIGHT_DISTANCE and 3 other fields | High correlation |
BOOKED_CLASS is highly correlated with BOOKED_CABIN and 3 other fields | High correlation |
BOOKED_CABIN is highly correlated with BOOKED_CLASS and 3 other fields | High correlation |
AIRCRAFT_TYPE is highly correlated with FLIGHT_DISTANCE and 8 other fields | High correlation |
VAB is highly correlated with FLIGHT_DISTANCE and 7 other fields | High correlation |
UPGRADE_TYPE is highly correlated with BOOKED_CABIN | High correlation |
ORIGINAL_TICKET_NUMBER is highly correlated with FORM_OF_PAYMENT | High correlation |
FORM_OF_PAYMENT is highly correlated with ORIGINAL_TICKET_NUMBER and 4 other fields | High correlation |
CURRENCY is highly correlated with FLIGHT_DISTANCE and 7 other fields | High correlation |
TOTAL_PRICE is highly correlated with CURRENCY | High correlation |
TOTAL_PRICE_PLN is highly correlated with BOOKED_CABIN and 1 other fields | High correlation |
PAX_TYPE is highly correlated with TOTAL_PRICE_PLN | High correlation |
SALES_MARKET is highly correlated with FORM_OF_PAYMENT and 4 other fields | High correlation |
SALES_CHANNEL is highly correlated with FORM_OF_PAYMENT | High correlation |
TRIP_TYPE is highly correlated with SEGMENTS | High correlation |
BOOKING_LONG_HOUL_FLAG is highly correlated with FLIGHT_DISTANCE and 7 other fields | High correlation |
FLIGHT_COUPONS is highly correlated with BOOKED_CLASS and 1 other fields | High correlation |
SEGMENTS is highly correlated with TRIP_TYPE | High correlation |
PAX_N is highly correlated with BOOKED_CLASS and 1 other fields | High correlation |
BOOKING_ORIGIN_COUNTRY_CODE is highly correlated with FLIGHT_DISTANCE and 8 other fields | High correlation |
BOOKING_DESTINATION_COUNTRY_CODE is highly correlated with FLIGHT_DISTANCE and 8 other fields | High correlation |
UPGRADE_TYPE has 9215782 (99.9%) missing values | Missing |
UPGRADE_SALES_DATE has 9215782 (99.9%) missing values | Missing |
LOYAL_CUSTOMER_ID has 7840881 (85.0%) missing values | Missing |
LOYAL_CUSTOMER_DATE_OF_BIRTH has 7848547 (85.1%) missing values | Missing |
LOYAL_CUSTOMER_REGISTERED_DATE has 7840881 (85.0%) missing values | Missing |
BOOKING_DESTINATION_AIRPORT has 1170692 (12.7%) missing values | Missing |
BOOKING_DESTINATION_COUNTRY_CODE has 1170692 (12.7%) missing values | Missing |
ORIGINAL_TICKET_NUMBER is highly skewed (γ1 = -50.30191515) | Skewed |
TOTAL_PRICE is highly skewed (γ1 = 117.8490263) | Skewed |
BOOKING_WINDOW_D has 166525 (1.8%) zeros | Zeros |
STAY_LENGTH_D has 321065 (3.5%) zeros | Zeros |
Reproduction
| Analysis started | 2022-03-19 13:39:40.709376 |
|---|---|
| Analysis finished | 2022-03-19 14:26:20.026961 |
| Duration | 46 minutes and 39.32 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
TICKET_NUMBER
Real number (ℝ≥0)
| Distinct | 3944503 |
|---|---|
| Distinct (%) | 42.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.000223243 × 1015 |
| Minimum | 621301964 |
|---|---|
| Maximum | 9.999996297 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 621301964 |
|---|---|
| 5-th percentile | 4.994320244 × 1014 |
| Q1 | 2.498187979 × 1015 |
| median | 5.002537448 × 1015 |
| Q3 | 7.498449973 × 1015 |
| 95-th percentile | 9.501769457 × 1015 |
| Maximum | 9.999996297 × 1015 |
| Range | 9.999995676 × 1015 |
| Interquartile range (IQR) | 5.000261994 × 1015 |
Descriptive statistics
| Standard deviation | 2.88698754 × 1015 |
|---|---|
| Coefficient of variation (CV) | 0.5773717293 |
| Kurtosis | -1.199361223 |
| Mean | 5.000223243 × 1015 |
| Median Absolute Deviation (MAD) | 2.500166606 × 1015 |
| Skewness | 0.0001303991867 |
| Sum | 8.13413659 × 1018 |
| Variance | 8.334697059 × 1030 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.232155151 × 1015 | 4 | < 0.1% |
| 8.660267309 × 1015 | 4 | < 0.1% |
| 1.63763202 × 1015 | 4 | < 0.1% |
| 1.659987109 × 1015 | 4 | < 0.1% |
| 1.406367008 × 1015 | 4 | < 0.1% |
| 4.580296817 × 1015 | 4 | < 0.1% |
| 9.40633882 × 1015 | 4 | < 0.1% |
| 3.331892901 × 1015 | 4 | < 0.1% |
| 2.349371658 × 1015 | 4 | < 0.1% |
| 1.01012609 × 1015 | 4 | < 0.1% |
| Other values (3944493) | 9224547 |
| Value | Count | Frequency (%) |
| 621301964 | 2 | |
| 1746237949 | 2 | |
| 6567071234 | 4 | |
| 6785107154 | 2 | |
| 7632136837 | 2 | |
| 9680810241 | 4 | |
| 1.047700429 × 1010 | 2 | |
| 1.073433151 × 1010 | 2 | |
| 1.769053404 × 1010 | 2 | |
| 1.839801168 × 1010 | 2 |
| Value | Count | Frequency (%) |
| 9.999996297 × 1015 | 2 | |
| 9.999994496 × 1015 | 4 | |
| 9.999993161 × 1015 | 4 | |
| 9.999991198 × 1015 | 1 | < 0.1% |
| 9.999988824 × 1015 | 2 | |
| 9.999980413 × 1015 | 4 | |
| 9.999980094 × 1015 | 2 | |
| 9.99997584 × 1015 | 2 | |
| 9.999972103 × 1015 | 2 | |
| 9.999958445 × 1015 | 4 |
COUPON_NUMBER
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| 1 | |
|---|---|
| 2 | |
| 3 | |
| 4 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 1 |
| 3rd row | 2 |
| 4th row | 1 |
| 5th row | 2 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 3944455 | |
| 2 | 3192507 | |
| 3 | 1048568 | 11.4% |
| 4 | 1039057 | 11.3% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 1 | 3944455 | |
| 2 | 3192507 | |
| 3 | 1048568 | 11.4% |
| 4 | 1039057 | 11.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 657 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| OUO | |
|---|---|
| LFF | 346275 |
| EIE | 182903 |
| LFN | 146284 |
| VMX | 143546 |
| Other values (652) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 103 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | WXA |
|---|---|
| 2nd row | OUO |
| 3rd row | OUO |
| 4th row | DZN |
| 5th row | LFF |
Common Values
| Value | Count | Frequency (%) |
| OUO | 4077079 | |
| LFF | 346275 | 3.8% |
| EIE | 182903 | 2.0% |
| LFN | 146284 | 1.6% |
| VMX | 143546 | 1.6% |
| GMW | 140460 | 1.5% |
| UGK | 140279 | 1.5% |
| FBI | 136799 | 1.5% |
| WXA | 128991 | 1.4% |
| NTH | 128869 | 1.4% |
| Other values (647) | 3653102 |
Length
| Value | Count | Frequency (%) |
| ouo | 4077079 | |
| lff | 346275 | 3.8% |
| eie | 182903 | 2.0% |
| lfn | 146284 | 1.6% |
| vmx | 143546 | 1.6% |
| gmw | 140460 | 1.5% |
| ugk | 140279 | 1.5% |
| fbi | 136799 | 1.5% |
| wxa | 128991 | 1.4% |
| nth | 128869 | 1.4% |
| Other values (647) | 3653102 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 679 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| OUO | |
|---|---|
| LFF | 325506 |
| EIE | 172335 |
| LFN | 149960 |
| FBI | 145271 |
| Other values (674) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 102 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OUO |
|---|---|
| 2nd row | RRS |
| 3rd row | HIX |
| 4th row | OUO |
| 5th row | NTH |
Common Values
| Value | Count | Frequency (%) |
| OUO | 4121121 | |
| LFF | 325506 | 3.5% |
| EIE | 172335 | 1.9% |
| LFN | 149960 | 1.6% |
| FBI | 145271 | 1.6% |
| UGK | 144139 | 1.6% |
| GMW | 141766 | 1.5% |
| VMX | 140077 | 1.5% |
| HIX | 129836 | 1.4% |
| UIT | 129380 | 1.4% |
| Other values (669) | 3625196 |
Length
| Value | Count | Frequency (%) |
| ouo | 4121121 | |
| lff | 325506 | 3.5% |
| eie | 172335 | 1.9% |
| lfn | 149960 | 1.6% |
| fbi | 145271 | 1.6% |
| ugk | 144139 | 1.6% |
| gmw | 141766 | 1.5% |
| vmx | 140077 | 1.5% |
| hix | 129836 | 1.4% |
| uit | 129380 | 1.4% |
| Other values (669) | 3625196 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 727 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| 2007-09-21 | 34059 |
|---|---|
| 2007-09-14 | 33767 |
| 2007-09-17 | 33341 |
| 2007-09-28 | 32822 |
| 2007-09-24 | 32600 |
| Other values (722) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2007-05-16 |
|---|---|
| 2nd row | 2007-08-26 |
| 3rd row | 2007-03-20 |
| 4th row | 2007-04-08 |
| 5th row | 2007-01-17 |
Common Values
| Value | Count | Frequency (%) |
| 2007-09-21 | 34059 | 0.4% |
| 2007-09-14 | 33767 | 0.4% |
| 2007-09-17 | 33341 | 0.4% |
| 2007-09-28 | 32822 | 0.4% |
| 2007-09-24 | 32600 | 0.4% |
| 2007-08-10 | 32328 | 0.4% |
| 2007-07-09 | 32304 | 0.4% |
| 2007-09-10 | 32280 | 0.3% |
| 2007-09-07 | 32212 | 0.3% |
| 2007-07-20 | 32204 | 0.3% |
| Other values (717) | 8896670 |
Length
| Value | Count | Frequency (%) |
| 2007-09-21 | 34059 | 0.4% |
| 2007-09-14 | 33767 | 0.4% |
| 2007-09-17 | 33341 | 0.4% |
| 2007-09-28 | 32822 | 0.4% |
| 2007-09-24 | 32600 | 0.4% |
| 2007-08-10 | 32328 | 0.4% |
| 2007-07-09 | 32304 | 0.4% |
| 2007-09-10 | 32280 | 0.3% |
| 2007-09-07 | 32212 | 0.3% |
| 2007-07-20 | 32204 | 0.3% |
| Other values (717) | 8896670 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1051 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 140.8 MiB |
| 00:00:00 | 226887 |
|---|---|
| 19:50:00 | 200875 |
| 14:40:00 | 171883 |
| 16:45:00 | 164385 |
| 07:20:00 | 164203 |
| Other values (1046) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 85 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 19:40:00 |
|---|---|
| 2nd row | 13:55:00 |
| 3rd row | 16:40:00 |
| 4th row | 06:05:00 |
| 5th row | 18:05:00 |
Common Values
| Value | Count | Frequency (%) |
| 00:00:00 | 226887 | 2.5% |
| 19:50:00 | 200875 | 2.2% |
| 14:40:00 | 171883 | 1.9% |
| 16:45:00 | 164385 | 1.8% |
| 07:20:00 | 164203 | 1.8% |
| 14:55:00 | 150588 | 1.6% |
| 17:05:00 | 146615 | 1.6% |
| 19:45:00 | 133143 | 1.4% |
| 16:30:00 | 128424 | 1.4% |
| 19:40:00 | 127238 | 1.4% |
| Other values (1041) | 7610344 |
Length
| Value | Count | Frequency (%) |
| 00:00:00 | 226887 | 2.5% |
| 19:50:00 | 200875 | 2.2% |
| 14:40:00 | 171883 | 1.9% |
| 16:45:00 | 164385 | 1.8% |
| 07:20:00 | 164203 | 1.8% |
| 14:55:00 | 150588 | 1.6% |
| 17:05:00 | 146615 | 1.6% |
| 19:45:00 | 133143 | 1.4% |
| 16:30:00 | 128424 | 1.4% |
| 19:40:00 | 127238 | 1.4% |
| Other values (1041) | 7610344 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 1688 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1814.180651 |
| Minimum | 0 |
|---|---|
| Maximum | 14507 |
| Zeros | 8 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 252 |
| Q1 | 550 |
| median | 984 |
| Q3 | 1460 |
| 95-th percentile | 7521 |
| Maximum | 14507 |
| Range | 14507 |
| Interquartile range (IQR) | 910 |
Descriptive statistics
| Standard deviation | 2303.818296 |
|---|---|
| Coefficient of variation (CV) | 1.269894646 |
| Kurtosis | 3.009986926 |
| Mean | 1814.180651 |
| Median Absolute Deviation (MAD) | 447 |
| Skewness | 2.093692771 |
| Sum | 1.673506725 × 1010 |
| Variance | 5307578.742 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 246 | 405676 | 4.4% |
| 1460 | 282015 | 3.1% |
| 1344 | 255041 | 2.8% |
| 1102 | 245560 | 2.7% |
| 984 | 229948 | 2.5% |
| 721 | 217810 | 2.4% |
| 2511 | 217445 | 2.4% |
| 402 | 214271 | 2.3% |
| 1160 | 200195 | 2.2% |
| 7521 | 194260 | 2.1% |
| Other values (1678) | 6762366 |
| Value | Count | Frequency (%) |
| 0 | 8 | < 0.1% |
| 9 | 2 | < 0.1% |
| 62 | 8 | < 0.1% |
| 90 | 135 | |
| 103 | 1 | < 0.1% |
| 108 | 1 | < 0.1% |
| 110 | 4 | < 0.1% |
| 117 | 2 | < 0.1% |
| 119 | 2 | < 0.1% |
| 128 | 9 | < 0.1% |
| Value | Count | Frequency (%) |
| 14507 | 1 | < 0.1% |
| 14131 | 4 | < 0.1% |
| 13175 | 1 | < 0.1% |
| 12466 | 1 | < 0.1% |
| 12240 | 6 | < 0.1% |
| 12178 | 2 | < 0.1% |
| 12005 | 1 | < 0.1% |
| 11497 | 1 | < 0.1% |
| 10890 | 2 | < 0.1% |
| 10869 | 1105 |
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 2 |
| Missing (%) | < 0.1% |
| Memory size | 140.8 MiB |
| SHORT-HAUL | |
|---|---|
| LONG-HAUL | |
| DOMESTIC | |
| UNKNOWN | 167 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.657471854 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SHORT-HAUL |
|---|---|
| 2nd row | LONG-HAUL |
| 3rd row | LONG-HAUL |
| 4th row | SHORT-HAUL |
| 5th row | SHORT-HAUL |
Common Values
| Value | Count | Frequency (%) |
| SHORT-HAUL | 7061558 | |
| LONG-HAUL | 1166541 | 12.6% |
| DOMESTIC | 996319 | 10.8% |
| UNKNOWN | 167 | < 0.1% |
| (Missing) | 2 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| short-haul | 7061558 | |
| long-haul | 1166541 | 12.6% |
| domestic | 996319 | 10.8% |
| unknown | 167 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
MARKETING_CARRIER
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 89 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.472350871 × 1015 |
| Minimum | 2.268751528 × 1014 |
|---|---|
| Maximum | 9.838732082 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 2.268751528 × 1014 |
|---|---|
| 5-th percentile | 2.434615205 × 1015 |
| Q1 | 2.434615205 × 1015 |
| median | 2.434615205 × 1015 |
| Q3 | 2.434615205 × 1015 |
| 95-th percentile | 2.434615205 × 1015 |
| Maximum | 9.838732082 × 1015 |
| Range | 9.611856929 × 1015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 4.36700163 × 1014 |
|---|---|
| Coefficient of variation (CV) | 0.176633571 |
| Kurtosis | 131.2053692 |
| Mean | 2.472350871 × 1015 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.95075707 |
| Sum | 6.240027701 × 1018 |
| Variance | 1.907070324 × 1029 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.434615205 × 1015 | 9077702 | |
| 5.403774244 × 1015 | 25368 | 0.3% |
| 2.099453761 × 1015 | 19567 | 0.2% |
| 1.319526191 × 1015 | 11766 | 0.1% |
| 7.495563552 × 1015 | 11634 | 0.1% |
| 7.711540388 × 1015 | 7700 | 0.1% |
| 4.849361541 × 1015 | 6952 | 0.1% |
| 7.346940931 × 1015 | 6690 | 0.1% |
| 3.858052475 × 1015 | 5809 | 0.1% |
| 8.304362752 × 1015 | 5434 | 0.1% |
| Other values (79) | 45965 | 0.5% |
| Value | Count | Frequency (%) |
| 2.268751528 × 1014 | 10 | < 0.1% |
| 2.455475406 × 1014 | 2923 | |
| 3.557699075 × 1014 | 214 | < 0.1% |
| 6.314863066 × 1014 | 342 | < 0.1% |
| 8.264698432 × 1014 | 16 | < 0.1% |
| 8.925619808 × 1014 | 284 | < 0.1% |
| 1.040662998 × 1015 | 59 | < 0.1% |
| 1.062886389 × 1015 | 20 | < 0.1% |
| 1.181685408 × 1015 | 9 | < 0.1% |
| 1.268037904 × 1015 | 1242 |
| Value | Count | Frequency (%) |
| 9.838732082 × 1015 | 4 | < 0.1% |
| 9.76316395 × 1015 | 1529 | |
| 9.590400398 × 1015 | 127 | < 0.1% |
| 9.411423626 × 1015 | 1255 | |
| 9.379265973 × 1015 | 2 | < 0.1% |
| 9.265787999 × 1015 | 708 | |
| 9.228032722 × 1015 | 83 | < 0.1% |
| 8.804634256 × 1015 | 661 | |
| 8.642649904 × 1015 | 948 | |
| 8.511667559 × 1015 | 596 | < 0.1% |
OPERATIONAL_CARRIER
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 90 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.552896636 × 1015 |
| Minimum | 2.268751528 × 1014 |
|---|---|
| Maximum | 9.838732082 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 2.268751528 × 1014 |
|---|---|
| 5-th percentile | 2.434615205 × 1015 |
| Q1 | 2.434615205 × 1015 |
| median | 2.434615205 × 1015 |
| Q3 | 2.434615205 × 1015 |
| 95-th percentile | 2.434615205 × 1015 |
| Maximum | 9.838732082 × 1015 |
| Range | 9.611856929 × 1015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7.563456611 × 1014 |
|---|---|
| Coefficient of variation (CV) | 0.2962695985 |
| Kurtosis | 42.09296726 |
| Mean | 2.552896636 × 1015 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.350476514 |
| Sum | -7.075065803 × 1018 |
| Variance | 5.720587591 × 1029 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.434615205 × 1015 | 8870764 | |
| 5.403774244 × 1015 | 70623 | 0.8% |
| 7.495563552 × 1015 | 42591 | 0.5% |
| 4.676356572 × 1015 | 35092 | 0.4% |
| 8.804634256 × 1015 | 31458 | 0.3% |
| 2.099453761 × 1015 | 22353 | 0.2% |
| 7.346940931 × 1015 | 19166 | 0.2% |
| 6.990908407 × 1015 | 18889 | 0.2% |
| 1.319526191 × 1015 | 14307 | 0.2% |
| 1.711731043 × 1015 | 12613 | 0.1% |
| Other values (80) | 86731 | 0.9% |
| Value | Count | Frequency (%) |
| 2.268751528 × 1014 | 10 | < 0.1% |
| 2.455475406 × 1014 | 5001 | |
| 3.557699075 × 1014 | 214 | < 0.1% |
| 6.314863066 × 1014 | 342 | < 0.1% |
| 8.264698432 × 1014 | 16 | < 0.1% |
| 8.925619808 × 1014 | 284 | < 0.1% |
| 1.040662998 × 1015 | 59 | < 0.1% |
| 1.062886389 × 1015 | 20 | < 0.1% |
| 1.181685408 × 1015 | 9 | < 0.1% |
| 1.268037904 × 1015 | 5228 |
| Value | Count | Frequency (%) |
| 9.838732082 × 1015 | 4 | < 0.1% |
| 9.76316395 × 1015 | 1529 | < 0.1% |
| 9.590400398 × 1015 | 127 | < 0.1% |
| 9.411423626 × 1015 | 1255 | < 0.1% |
| 9.379265973 × 1015 | 2 | < 0.1% |
| 9.265787999 × 1015 | 707 | < 0.1% |
| 9.228032722 × 1015 | 83 | < 0.1% |
| 8.804634256 × 1015 | 31458 | |
| 8.642649904 × 1015 | 948 | < 0.1% |
| 8.511667559 × 1015 | 596 | < 0.1% |
| Distinct | 26 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| L | |
|---|---|
| W | |
| V | |
| U | |
| S | |
| Other values (21) |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | O |
|---|---|
| 2nd row | U |
| 3rd row | U |
| 4th row | W |
| 5th row | W |
Common Values
| Value | Count | Frequency (%) |
| L | 1208736 | |
| W | 1159102 | |
| V | 1008351 | |
| U | 1000495 | |
| S | 769101 | |
| T | 707038 | |
| O | 703695 | |
| Q | 555528 | |
| G | 415344 | 4.5% |
| K | 372493 | 4.0% |
| Other values (16) | 1324704 |
Length
| Value | Count | Frequency (%) |
| l | 1208736 | |
| w | 1159102 | |
| v | 1008351 | |
| u | 1000495 | |
| s | 769101 | |
| t | 707038 | |
| o | 703695 | |
| q | 555528 | |
| g | 415344 | 4.5% |
| k | 372493 | 4.0% |
| Other values (15) | 1324703 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Memory size | 140.8 MiB |
| Economy | |
|---|---|
| Premium | 280443 |
| Business | 235720 |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.02555345 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Economy |
|---|---|
| 2nd row | Economy |
| 3rd row | Economy |
| 4th row | Economy |
| 5th row | Economy |
Common Values
| Value | Count | Frequency (%) |
| Economy | 8708423 | |
| Premium | 280443 | 3.0% |
| Business | 235720 | 2.6% |
| (Missing) | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| economy | 8708423 | |
| premium | 280443 | 3.0% |
| business | 235720 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| DH4 | |
|---|---|
| E75 | |
| E95 | |
| 738 | |
| 788 | |
| Other values (60) |
Length
| Max length | 7 |
|---|---|
| Median length | 3 |
| Mean length | 3.073440253 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 738 |
|---|---|
| 2nd row | 788 |
| 3rd row | 788 |
| 4th row | E75 |
| 5th row | CRN |
Common Values
| Value | Count | Frequency (%) |
| DH4 | 1123835 | |
| E75 | 1091080 | |
| E95 | 895297 | |
| 738 | 776429 | |
| 788 | 715728 | 7.8% |
| CR9 | 691160 | 7.5% |
| 7M8 | 640839 | 6.9% |
| E9A | 557339 | 6.0% |
| E70 | 477442 | 5.2% |
| 73H | 435696 | 4.7% |
| Other values (55) | 1819742 |
Length
| Value | Count | Frequency (%) |
| dh4 | 1123835 | |
| e75 | 1091080 | |
| e95 | 895297 | |
| 738 | 776429 | |
| 788 | 715728 | 7.8% |
| cr9 | 691160 | 7.5% |
| 7m8 | 640839 | 6.9% |
| e9a | 557339 | 6.0% |
| e70 | 477442 | 5.2% |
| 73h | 435696 | 4.7% |
| Other values (55) | 1819742 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 33211 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| GIT | 222686 |
|---|---|
| LSAVI0 | 95304 |
| USAVI0 | 87918 |
| OZSAVJ0 | 70761 |
| VSAVK0 | 69933 |
| Other values (33206) |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 3759 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OZSTDJ0 |
|---|---|
| 2nd row | UKPRO10 |
| 3rd row | ULPRO11 |
| 4th row | WSTDK0 |
| 5th row | WCSERT/UD10 |
Common Values
| Value | Count | Frequency (%) |
| GIT | 222686 | 2.4% |
| LSAVI0 | 95304 | 1.0% |
| USAVI0 | 87918 | 1.0% |
| OZSAVJ0 | 70761 | 0.8% |
| VSAVK0 | 69933 | 0.8% |
| WSAVK0 | 69253 | 0.8% |
| WSAVI0 | 67337 | 0.7% |
| TLOSEA | 65120 | 0.7% |
| VSTDK0 | 56695 | 0.6% |
| USAVG0 | 55945 | 0.6% |
| Other values (33201) | 8363635 |
Length
| Value | Count | Frequency (%) |
| git | 222696 | 2.4% |
| lsavi0 | 95309 | 1.0% |
| usavi0 | 87929 | 1.0% |
| ozsavj0 | 70778 | 0.8% |
| vsavk0 | 69936 | 0.8% |
| wsavk0 | 69258 | 0.8% |
| wsavi0 | 67349 | 0.7% |
| tlosea | 65120 | 0.7% |
| vstdk0 | 56703 | 0.6% |
| usavg0 | 55970 | 0.6% |
| Other values (32329) | 8368540 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| SAVER | |
|---|---|
| STANDARD | |
| OTHER | |
| FLEX | |
| SEMI-FLEX | |
| Other values (2) | 263586 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.938575028 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STANDARD |
|---|---|
| 2nd row | BASIC |
| 3rd row | BASIC |
| 4th row | STANDARD |
| 5th row | OTHER |
Common Values
| Value | Count | Frequency (%) |
| SAVER | 3251123 | |
| STANDARD | 2563924 | |
| OTHER | 2098035 | |
| FLEX | 699229 | 7.6% |
| SEMI-FLEX | 348690 | 3.8% |
| BASIC | 195920 | 2.1% |
| FULL-FLEX | 67666 | 0.7% |
Length
Pie chart
| Value | Count | Frequency (%) |
| saver | 3251123 | |
| standard | 2563924 | |
| other | 2098035 | |
| flex | 699229 | 7.6% |
| semi-flex | 348690 | 3.8% |
| basic | 195920 | 2.1% |
| full-flex | 67666 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 MiB |
| False | |
|---|---|
| True | 8805 |
| Value | Count | Frequency (%) |
| False | 9215782 | |
| True | 8805 | 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 9215782 |
| Missing (%) | 99.9% |
| Memory size | 140.8 MiB |
| lot upgrade | |
|---|---|
| upgrade | |
| upgrade at gate | |
| upg econ to premium | |
| upg econ to business |
Length
| Max length | 23 |
|---|---|
| Median length | 11 |
| Mean length | 12.88279387 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | upg premium to business |
|---|---|
| 2nd row | lot upgrade |
| 3rd row | upgrade |
| 4th row | lot upgrade |
| 5th row | lot upgrade |
Common Values
| Value | Count | Frequency (%) |
| lot upgrade | 3397 | < 0.1% |
| upgrade | 1966 | < 0.1% |
| upgrade at gate | 1359 | < 0.1% |
| upg econ to premium | 1046 | < 0.1% |
| upg econ to business | 602 | < 0.1% |
| upg premium to business | 435 | < 0.1% |
| (Missing) | 9215782 |
Length
Pie chart
| Value | Count | Frequency (%) |
| upgrade | 6722 | |
| lot | 3397 | |
| upg | 2083 | 9.8% |
| to | 2083 | 9.8% |
| econ | 1648 | 7.8% |
| premium | 1481 | 7.0% |
| at | 1359 | 6.4% |
| gate | 1359 | 6.4% |
| business | 1037 | 4.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 481 |
|---|---|
| Distinct (%) | 5.5% |
| Missing | 9215782 |
| Missing (%) | 99.9% |
| Memory size | 140.8 MiB |
| 2007-11-05 | 52 |
|---|---|
| 2007-10-15 | 52 |
| 2007-12-15 | 50 |
| 2007-09-25 | 49 |
| 2007-09-29 | 48 |
| Other values (476) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 58 ? |
|---|---|
| Unique (%) | 0.7% |
Sample
| 1st row | 2007-01-11 |
|---|---|
| 2nd row | 2007-02-04 |
| 3rd row | 2007-05-15 |
| 4th row | 2007-01-24 |
| 5th row | 2007-02-04 |
Common Values
| Value | Count | Frequency (%) |
| 2007-11-05 | 52 | < 0.1% |
| 2007-10-15 | 52 | < 0.1% |
| 2007-12-15 | 50 | < 0.1% |
| 2007-09-25 | 49 | < 0.1% |
| 2007-09-29 | 48 | < 0.1% |
| 2007-08-21 | 47 | < 0.1% |
| 2007-05-24 | 47 | < 0.1% |
| 2007-09-04 | 47 | < 0.1% |
| 2007-05-27 | 47 | < 0.1% |
| 2007-12-26 | 47 | < 0.1% |
| Other values (471) | 8319 | 0.1% |
| (Missing) | 9215782 |
Length
| Value | Count | Frequency (%) |
| 2007-11-05 | 52 | 0.6% |
| 2007-10-15 | 52 | 0.6% |
| 2007-12-15 | 50 | 0.6% |
| 2007-09-25 | 49 | 0.6% |
| 2007-09-29 | 48 | 0.5% |
| 2007-08-21 | 47 | 0.5% |
| 2007-05-24 | 47 | 0.5% |
| 2007-09-04 | 47 | 0.5% |
| 2007-05-27 | 47 | 0.5% |
| 2007-12-26 | 47 | 0.5% |
| Other values (471) | 8319 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
BOOKING_ID
Real number (ℝ≥0)
| Distinct | 2795940 |
|---|---|
| Distinct (%) | 30.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.999167484 × 1015 |
| Minimum | 1.4787909 × 1010 |
|---|---|
| Maximum | 9.999993604 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 1.4787909 × 1010 |
|---|---|
| 5-th percentile | 4.996979081 × 1014 |
| Q1 | 2.502587582 × 1015 |
| median | 4.995274085 × 1015 |
| Q3 | 7.500628424 × 1015 |
| 95-th percentile | 9.498853657 × 1015 |
| Maximum | 9.999993604 × 1015 |
| Range | 9.999978816 × 1015 |
| Interquartile range (IQR) | 4.998040842 × 1015 |
Descriptive statistics
| Standard deviation | 2.885806653 × 1015 |
|---|---|
| Coefficient of variation (CV) | 0.5772574459 |
| Kurtosis | -1.199414561 |
| Mean | 4.999167484 × 1015 |
| Median Absolute Deviation (MAD) | 2.498697906 × 1015 |
| Skewness | 0.00160428563 |
| Sum | -1.604802714 × 1018 |
| Variance | 8.327880039 × 1030 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 7.814006325 × 1015 | 279 | < 0.1% |
| 6.413885912 × 1015 | 248 | < 0.1% |
| 9.330436931 × 1015 | 232 | < 0.1% |
| 8.124407744 × 1015 | 222 | < 0.1% |
| 9.20838413 × 1015 | 220 | < 0.1% |
| 4.073011969 × 1014 | 216 | < 0.1% |
| 5.503728085 × 1015 | 216 | < 0.1% |
| 9.845896655 × 1015 | 216 | < 0.1% |
| 2.741427892 × 1015 | 212 | < 0.1% |
| 5.469900034 × 1015 | 210 | < 0.1% |
| Other values (2795930) | 9222316 |
| Value | Count | Frequency (%) |
| 1.4787909 × 1010 | 2 | < 0.1% |
| 1.708659761 × 1010 | 4 | < 0.1% |
| 1.996479238 × 1010 | 2 | < 0.1% |
| 2.421156679 × 1010 | 2 | < 0.1% |
| 3.152591026 × 1010 | 4 | < 0.1% |
| 3.300183668 × 1010 | 2 | < 0.1% |
| 4.150214043 × 1010 | 4 | < 0.1% |
| 4.183495346 × 1010 | 4 | < 0.1% |
| 4.396179757 × 1010 | 8 | |
| 4.641041529 × 1010 | 16 |
| Value | Count | Frequency (%) |
| 9.999993604 × 1015 | 2 | < 0.1% |
| 9.999991575 × 1015 | 2 | < 0.1% |
| 9.999988806 × 1015 | 4 | |
| 9.99998833 × 1015 | 4 | |
| 9.999985817 × 1015 | 8 | |
| 9.999985519 × 1015 | 2 | < 0.1% |
| 9.999982392 × 1015 | 2 | < 0.1% |
| 9.99998141 × 1015 | 2 | < 0.1% |
| 9.999970594 × 1015 | 2 | < 0.1% |
| 9.999969169 × 1015 | 2 | < 0.1% |
| Distinct | 3310 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.376164102 × 1015 |
| Minimum | 2.334519661 × 1012 |
|---|---|
| Maximum | 9.998792831 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 2.334519661 × 1012 |
|---|---|
| 5-th percentile | 9.379265973 × 1015 |
| Q1 | 9.379265973 × 1015 |
| median | 9.379265973 × 1015 |
| Q3 | 9.379265973 × 1015 |
| 95-th percentile | 9.379265973 × 1015 |
| Maximum | 9.998792831 × 1015 |
| Range | 9.996458311 × 1015 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.395686988 × 1014 |
|---|---|
| Coefficient of variation (CV) | 0.01488547953 |
| Kurtosis | 2696.179345 |
| Mean | 9.376164102 × 1015 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -50.30191515 |
| Sum | -5.541480552 × 1018 |
| Variance | 1.94794217 × 1028 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 9.379265973 × 1015 | 9218034 | |
| 3.981966873 × 1015 | 10 | < 0.1% |
| 7.971162458 × 1013 | 10 | < 0.1% |
| 1.306124545 × 1015 | 10 | < 0.1% |
| 8.460182694 × 1015 | 10 | < 0.1% |
| 4.834231548 × 1015 | 8 | < 0.1% |
| 7.62507682 × 1015 | 8 | < 0.1% |
| 9.568725185 × 1015 | 8 | < 0.1% |
| 1.721215489 × 1015 | 7 | < 0.1% |
| 6.82357158 × 1015 | 6 | < 0.1% |
| Other values (3300) | 6476 | 0.1% |
| Value | Count | Frequency (%) |
| 2.334519661 × 1012 | 2 | |
| 8.145144489 × 1012 | 2 | |
| 1.002984636 × 1013 | 1 | < 0.1% |
| 1.368096309 × 1013 | 1 | < 0.1% |
| 2.110182871 × 1013 | 2 | |
| 2.173339016 × 1013 | 4 | |
| 4.265450911 × 1013 | 4 | |
| 4.373848398 × 1013 | 1 | < 0.1% |
| 4.55339565 × 1013 | 2 | |
| 4.70488326 × 1013 | 2 |
| Value | Count | Frequency (%) |
| 9.998792831 × 1015 | 1 | |
| 9.99759638 × 1015 | 2 | |
| 9.995602871 × 1015 | 2 | |
| 9.995032605 × 1015 | 2 | |
| 9.993920037 × 1015 | 2 | |
| 9.987224125 × 1015 | 1 | |
| 9.976617261 × 1015 | 1 | |
| 9.975232462 × 1015 | 2 | |
| 9.962332105 × 1015 | 1 | |
| 9.961439234 × 1015 | 1 |
| Distinct | 79 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| CA | |
|---|---|
| CCCA5 | |
| CCVI4 | |
| CCAX3 | |
| CCTP1 | 270349 |
| Other values (74) |
Length
| Max length | 5 |
|---|---|
| Median length | 5 |
| Mean length | 5 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CA |
|---|---|
| 2nd row | CA |
| 3rd row | CCVI4 |
| 4th row | CA |
| 5th row | CA |
Common Values
| Value | Count | Frequency (%) |
| CA | 3181526 | |
| CCCA5 | 2552070 | |
| CCVI4 | 1706369 | |
| CCAX3 | 720072 | 7.8% |
| CCTP1 | 270349 | 2.9% |
| DOTPA | 235214 | 2.5% |
| PAYPA | 168891 | 1.8% |
| CCDC3 | 120727 | 1.3% |
| INVOI | 103639 | 1.1% |
| INTER | 38002 | 0.4% |
| Other values (69) | 127728 | 1.4% |
Length
| Value | Count | Frequency (%) |
| ca | 3181526 | |
| ccca5 | 2552070 | |
| ccvi4 | 1706369 | |
| ccax3 | 720072 | 7.8% |
| cctp1 | 270349 | 2.9% |
| dotpa | 235214 | 2.5% |
| paypa | 168891 | 1.8% |
| ccdc3 | 120727 | 1.3% |
| invoi | 103639 | 1.1% |
| inter | 38002 | 0.4% |
| Other values (70) | 131488 | 1.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 38 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| EUR | |
|---|---|
| PLN | |
| USD | |
| SEK | |
| UAH | |
| Other values (33) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PLN |
|---|---|
| 2nd row | EUR |
| 3rd row | USD |
| 4th row | UAH |
| 5th row | EUR |
Common Values
| Value | Count | Frequency (%) |
| EUR | 2981011 | |
| PLN | 2323316 | |
| USD | 1142780 | 12.4% |
| SEK | 597344 | 6.5% |
| UAH | 315625 | 3.4% |
| RUB | 273962 | 3.0% |
| GBP | 271065 | 2.9% |
| CAD | 234220 | 2.5% |
| KRW | 155622 | 1.7% |
| DKK | 122084 | 1.3% |
| Other values (28) | 807558 | 8.8% |
Length
| Value | Count | Frequency (%) |
| eur | 2981011 | |
| pln | 2323316 | |
| usd | 1142780 | 12.4% |
| sek | 597344 | 6.5% |
| uah | 315625 | 3.4% |
| rub | 273962 | 3.0% |
| gbp | 271065 | 2.9% |
| cad | 234220 | 2.5% |
| krw | 155622 | 1.7% |
| dkk | 122084 | 1.3% |
| Other values (27) | 807529 | 8.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 363032 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25080.2803 |
| Minimum | -1564.6 |
|---|---|
| Maximum | 107910000 |
| Zeros | 4226 |
| Zeros (%) | < 0.1% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | -1564.6 |
|---|---|
| 5-th percentile | 130.99 |
| Q1 | 280.11 |
| median | 786.14 |
| Q3 | 1819 |
| 95-th percentile | 23907 |
| Maximum | 107910000 |
| Range | 107911564.6 |
| Interquartile range (IQR) | 1538.89 |
Descriptive statistics
| Standard deviation | 223500.6036 |
|---|---|
| Coefficient of variation (CV) | 8.911407724 |
| Kurtosis | 38421.76424 |
| Mean | 25080.2803 |
| Median Absolute Deviation (MAD) | 560.67 |
| Skewness | 117.8490263 |
| Sum | 2.313552276 × 1011 |
| Variance | 4.995251981 × 1010 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4226 | < 0.1% |
| 240 | 2720 | < 0.1% |
| 229.34 | 1994 | < 0.1% |
| 99.9 | 1866 | < 0.1% |
| 189.52 | 1695 | < 0.1% |
| 209.34 | 1679 | < 0.1% |
| 980 | 1598 | < 0.1% |
| 156.21 | 1532 | < 0.1% |
| 2532 | 1395 | < 0.1% |
| 190.6 | 1384 | < 0.1% |
| Other values (363022) | 9204498 |
| Value | Count | Frequency (%) |
| -1564.6 | 3 | < 0.1% |
| 0 | 4226 | |
| 0.03 | 2 | < 0.1% |
| 0.04 | 2 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.1 | 2 | < 0.1% |
| 0.2 | 4 | < 0.1% |
| 0.53 | 28 | < 0.1% |
| 0.6 | 1 | < 0.1% |
| 1 | 62 | < 0.1% |
| Value | Count | Frequency (%) |
| 107910000 | 4 | |
| 71512000 | 2 | < 0.1% |
| 64537000 | 3 | < 0.1% |
| 59452000 | 2 | < 0.1% |
| 58939000 | 4 | |
| 57872000 | 2 | < 0.1% |
| 55412000 | 6 | |
| 50779000 | 8 | |
| 37874000 | 2 | < 0.1% |
| 35501000 | 2 | < 0.1% |
| Distinct | 473960 |
|---|---|
| Distinct (%) | 5.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1688.65867 |
| Minimum | -5328.25 |
|---|---|
| Maximum | 49075.99 |
| Zeros | 4226 |
| Zeros (%) | < 0.1% |
| Negative | 3 |
| Negative (%) | < 0.1% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | -5328.25 |
|---|---|
| 5-th percentile | 432.78 |
| Q1 | 782.51 |
| median | 1162.92 |
| Q3 | 2052 |
| 95-th percentile | 4336.297 |
| Maximum | 49075.99 |
| Range | 54404.24 |
| Interquartile range (IQR) | 1269.49 |
Descriptive statistics
| Standard deviation | 1672.056032 |
|---|---|
| Coefficient of variation (CV) | 0.9901681501 |
| Kurtosis | 34.25929433 |
| Mean | 1688.65867 |
| Median Absolute Deviation (MAD) | 481.36 |
| Skewness | 4.427305766 |
| Sum | 1.557717882 × 1010 |
| Variance | 2795771.373 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 4226 | < 0.1% |
| 60.59 | 1150 | < 0.1% |
| 1371.08 | 965 | < 0.1% |
| 1239.49 | 828 | < 0.1% |
| 429.79 | 563 | < 0.1% |
| 399.43 | 400 | < 0.1% |
| 1429.81 | 381 | < 0.1% |
| 349.07 | 375 | < 0.1% |
| 3211.84 | 339 | < 0.1% |
| 1759.05 | 318 | < 0.1% |
| Other values (473950) | 9215042 |
| Value | Count | Frequency (%) |
| -5328.25 | 3 | < 0.1% |
| 0 | 4226 | |
| 0.03 | 2 | < 0.1% |
| 0.08 | 2 | < 0.1% |
| 0.17 | 2 | < 0.1% |
| 0.2 | 3 | < 0.1% |
| 0.43 | 2 | < 0.1% |
| 0.67 | 1 | < 0.1% |
| 0.85 | 1 | < 0.1% |
| 0.9 | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 49075.99 | 4 | |
| 48898.13 | 4 | |
| 42351.54 | 4 | |
| 40716.98 | 4 | |
| 40447.81 | 3 | |
| 40301.44 | 4 | |
| 37710.93 | 3 | |
| 35749.98 | 6 | |
| 35723.83 | 4 | |
| 35681.94 | 4 |
PAX_GENDER
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| M | |
|---|---|
| F |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | M |
|---|---|
| 2nd row | M |
| 3rd row | F |
| 4th row | F |
| 5th row | M |
Common Values
| Value | Count | Frequency (%) |
| M | 6549164 | |
| F | 2675423 |
Length
Pie chart
| Value | Count | Frequency (%) |
| m | 6549164 | |
| f | 2675423 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| ADULT | |
|---|---|
| CHILD | 144947 |
| INFANT | 34179 |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.003705207 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ADULT |
|---|---|
| 2nd row | ADULT |
| 3rd row | ADULT |
| 4th row | ADULT |
| 5th row | ADULT |
Common Values
| Value | Count | Frequency (%) |
| ADULT | 9045461 | |
| CHILD | 144947 | 1.6% |
| INFANT | 34179 | 0.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| adult | 9045461 | |
| child | 144947 | 1.6% |
| infant | 34179 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
CORPORATE_CONTRACT_FLG
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 MiB |
| False | |
|---|---|
| True | 272502 |
| Value | Count | Frequency (%) |
| False | 8952085 | |
| True | 272502 | 3.0% |
LOYAL_CUSTOMER
Boolean
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 7840881 | |
| True | 1383706 | 15.0% |
| Distinct | 265358 |
|---|---|
| Distinct (%) | 19.2% |
| Missing | 7840881 |
| Missing (%) | 85.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.984529267 × 1015 |
| Minimum | 1.389848426 × 1010 |
|---|---|
| Maximum | 9.999998028 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 1.389848426 × 1010 |
|---|---|
| 5-th percentile | 4.887175725 × 1014 |
| Q1 | 2.483612606 × 1015 |
| median | 4.977264159 × 1015 |
| Q3 | 7.484234464 × 1015 |
| 95-th percentile | 9.490646602 × 1015 |
| Maximum | 9.999998028 × 1015 |
| Range | 9.999984129 × 1015 |
| Interquartile range (IQR) | 5.000621858 × 1015 |
Descriptive statistics
| Standard deviation | 2.889320868 × 1015 |
|---|---|
| Coefficient of variation (CV) | 0.5796577196 |
| Kurtosis | -1.198005069 |
| Mean | 4.984529267 × 1015 |
| Median Absolute Deviation (MAD) | 2.501096772 × 1015 |
| Skewness | 0.005668665518 |
| Sum | 6.897123054 × 1021 |
| Variance | 8.34817508 × 1030 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.910455974 × 1015 | 216 | < 0.1% |
| 7.649390971 × 1015 | 171 | < 0.1% |
| 6.057484602 × 1015 | 160 | < 0.1% |
| 8.30918744 × 1014 | 158 | < 0.1% |
| 5.789314198 × 1014 | 155 | < 0.1% |
| 9.922290221 × 1015 | 150 | < 0.1% |
| 7.052728341 × 1015 | 148 | < 0.1% |
| 8.957362722 × 1015 | 144 | < 0.1% |
| 4.953263798 × 1015 | 144 | < 0.1% |
| 3.020371903 × 1015 | 141 | < 0.1% |
| Other values (265348) | 1382119 | 15.0% |
| (Missing) | 7840881 |
| Value | Count | Frequency (%) |
| 1.389848426 × 1010 | 2 | < 0.1% |
| 1.695067404 × 1011 | 4 | < 0.1% |
| 1.790219526 × 1011 | 21 | |
| 2.267783645 × 1011 | 6 | < 0.1% |
| 2.567251252 × 1011 | 4 | < 0.1% |
| 2.608901449 × 1011 | 4 | < 0.1% |
| 3.200981632 × 1011 | 1 | < 0.1% |
| 3.645997832 × 1011 | 4 | < 0.1% |
| 3.795908228 × 1011 | 1 | < 0.1% |
| 4.320790139 × 1011 | 14 |
| Value | Count | Frequency (%) |
| 9.999998028 × 1015 | 2 | < 0.1% |
| 9.999983475 × 1015 | 1 | < 0.1% |
| 9.999910337 × 1015 | 4 | |
| 9.999840581 × 1015 | 4 | |
| 9.999808045 × 1015 | 2 | < 0.1% |
| 9.999776868 × 1015 | 2 | < 0.1% |
| 9.999767465 × 1015 | 9 | |
| 9.999753454 × 1015 | 4 | |
| 9.999691793 × 1015 | 8 | |
| 9.999579353 × 1015 | 6 |
| Distinct | 24920 |
|---|---|
| Distinct (%) | 1.8% |
| Missing | 7848547 |
| Missing (%) | 85.1% |
| Memory size | 140.8 MiB |
| 1964-04-20 | 358 |
|---|---|
| 1967-08-25 | 358 |
| 1969-07-18 | 332 |
| 1971-05-21 | 326 |
| 1960-11-23 | 309 |
| Other values (24915) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 222 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1961-03-26 |
|---|---|
| 2nd row | 1979-09-12 |
| 3rd row | 1951-10-15 |
| 4th row | 1943-11-01 |
| 5th row | 1966-07-04 |
Common Values
| Value | Count | Frequency (%) |
| 1964-04-20 | 358 | < 0.1% |
| 1967-08-25 | 358 | < 0.1% |
| 1969-07-18 | 332 | < 0.1% |
| 1971-05-21 | 326 | < 0.1% |
| 1960-11-23 | 309 | < 0.1% |
| 1967-03-03 | 305 | < 0.1% |
| 1966-07-21 | 304 | < 0.1% |
| 1970-12-20 | 304 | < 0.1% |
| 1970-06-12 | 302 | < 0.1% |
| 1967-04-14 | 302 | < 0.1% |
| Other values (24910) | 1372840 | 14.9% |
| (Missing) | 7848547 |
Length
| Value | Count | Frequency (%) |
| 1964-04-20 | 358 | < 0.1% |
| 1967-08-25 | 358 | < 0.1% |
| 1969-07-18 | 332 | < 0.1% |
| 1971-05-21 | 326 | < 0.1% |
| 1960-11-23 | 309 | < 0.1% |
| 1967-03-03 | 305 | < 0.1% |
| 1966-07-21 | 304 | < 0.1% |
| 1970-12-20 | 304 | < 0.1% |
| 1970-06-12 | 302 | < 0.1% |
| 1967-04-14 | 302 | < 0.1% |
| Other values (24910) | 1372840 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 8930 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 7840881 |
| Missing (%) | 85.0% |
| Memory size | 140.8 MiB |
| 1991-12-01 | 19093 |
|---|---|
| 1991-11-30 | 10357 |
| 1991-12-03 | 7600 |
| 1991-11-29 | 5689 |
| 1996-06-14 | 4776 |
| Other values (8925) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 35 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 1996-06-13 |
|---|---|
| 2nd row | 2006-10-22 |
| 3rd row | 1986-04-03 |
| 4th row | 1988-05-27 |
| 5th row | 2003-11-21 |
Common Values
| Value | Count | Frequency (%) |
| 1991-12-01 | 19093 | 0.2% |
| 1991-11-30 | 10357 | 0.1% |
| 1991-12-03 | 7600 | 0.1% |
| 1991-11-29 | 5689 | 0.1% |
| 1996-06-14 | 4776 | 0.1% |
| 1996-06-13 | 4724 | 0.1% |
| 1992-02-18 | 4149 | < 0.1% |
| 1996-08-20 | 4147 | < 0.1% |
| 1992-02-20 | 3318 | < 0.1% |
| 1996-06-24 | 2828 | < 0.1% |
| Other values (8920) | 1317025 | 14.3% |
| (Missing) | 7840881 |
Length
| Value | Count | Frequency (%) |
| 1991-12-01 | 19093 | 1.4% |
| 1991-11-30 | 10357 | 0.7% |
| 1991-12-03 | 7600 | 0.5% |
| 1991-11-29 | 5689 | 0.4% |
| 1996-06-14 | 4776 | 0.3% |
| 1996-06-13 | 4724 | 0.3% |
| 1992-02-18 | 4149 | 0.3% |
| 1996-08-20 | 4147 | 0.3% |
| 1992-02-20 | 3318 | 0.2% |
| 1996-06-24 | 2828 | 0.2% |
| Other values (8920) | 1317025 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 365 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| 2007-01-10 | 56382 |
|---|---|
| 2007-01-11 | 46672 |
| 2007-01-12 | 45940 |
| 2007-01-23 | 43905 |
| 2007-01-16 | 42545 |
| Other values (360) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2007-01-11 |
|---|---|
| 2nd row | 2007-01-10 |
| 3rd row | 2007-01-10 |
| 4th row | 2007-03-27 |
| 5th row | 2007-01-10 |
Common Values
| Value | Count | Frequency (%) |
| 2007-01-10 | 56382 | 0.6% |
| 2007-01-11 | 46672 | 0.5% |
| 2007-01-12 | 45940 | 0.5% |
| 2007-01-23 | 43905 | 0.5% |
| 2007-01-16 | 42545 | 0.5% |
| 2007-01-17 | 41739 | 0.5% |
| 2007-01-15 | 41155 | 0.4% |
| 2007-01-19 | 40698 | 0.4% |
| 2007-01-22 | 40018 | 0.4% |
| 2007-04-10 | 39449 | 0.4% |
| Other values (355) | 8786084 |
Length
| Value | Count | Frequency (%) |
| 2007-01-10 | 56382 | 0.6% |
| 2007-01-11 | 46672 | 0.5% |
| 2007-01-12 | 45940 | 0.5% |
| 2007-01-23 | 43905 | 0.5% |
| 2007-01-16 | 42545 | 0.5% |
| 2007-01-17 | 41739 | 0.5% |
| 2007-01-15 | 41155 | 0.4% |
| 2007-01-19 | 40698 | 0.4% |
| 2007-01-22 | 40018 | 0.4% |
| 2007-04-10 | 39449 | 0.4% |
| Other values (355) | 8786084 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 72 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.451603946 × 1015 |
| Minimum | 1.436722689 × 1014 |
|---|---|
| Maximum | 9.831241332 × 1015 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 1.436722689 × 1014 |
|---|---|
| 5-th percentile | 1.319526191 × 1015 |
| Q1 | 2.460355647 × 1015 |
| median | 4.676356572 × 1015 |
| Q3 | 5.918065357 × 1015 |
| 95-th percentile | 7.445666649 × 1015 |
| Maximum | 9.831241332 × 1015 |
| Range | 9.687569063 × 1015 |
| Interquartile range (IQR) | 3.45770971 × 1015 |
Descriptive statistics
| Standard deviation | 2.111584968 × 1015 |
|---|---|
| Coefficient of variation (CV) | 0.4743425053 |
| Kurtosis | -0.514131839 |
| Mean | 4.451603946 × 1015 |
| Median Absolute Deviation (MAD) | 2.216000925 × 1015 |
| Skewness | 0.2752812975 |
| Sum | 1.755584477 × 1018 |
| Variance | 4.458791079 × 1030 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2.460355647 × 1015 | 2323721 | |
| 6.982998843 × 1015 | 956026 | 10.4% |
| 5.492600423 × 1015 | 760762 | 8.2% |
| 3.823004278 × 1015 | 597118 | 6.5% |
| 4.676356572 × 1015 | 335815 | 3.6% |
| 1.319526191 × 1015 | 315543 | 3.4% |
| 5.218436845 × 1015 | 273820 | 3.0% |
| 5.703060121 × 1015 | 272958 | 3.0% |
| 6.745023307 × 1015 | 271118 | 2.9% |
| 4.680091206 × 1015 | 251416 | 2.7% |
| Other values (62) | 2866290 |
| Value | Count | Frequency (%) |
| 1.436722689 × 1014 | 3277 | < 0.1% |
| 2.200278881 × 1014 | 42501 | 0.5% |
| 4.272004361 × 1014 | 86565 | 0.9% |
| 4.346767962 × 1014 | 101387 | 1.1% |
| 5.522629473 × 1014 | 14012 | 0.2% |
| 1.040662998 × 1015 | 593 | < 0.1% |
| 1.268037904 × 1015 | 86422 | 0.9% |
| 1.319526191 × 1015 | 315543 | |
| 1.51438236 × 1015 | 53419 | 0.6% |
| 2.099453761 × 1015 | 48389 | 0.5% |
| Value | Count | Frequency (%) |
| 9.831241332 × 1015 | 159103 | |
| 9.509246387 × 1015 | 4178 | < 0.1% |
| 9.475875089 × 1015 | 15739 | 0.2% |
| 9.306828478 × 1015 | 33583 | 0.4% |
| 9.265787999 × 1015 | 95950 | |
| 9.172083597 × 1015 | 195 | < 0.1% |
| 9.071749734 × 1015 | 57 | < 0.1% |
| 8.666019511 × 1015 | 14392 | 0.2% |
| 8.642649904 × 1015 | 729 | < 0.1% |
| 8.557423498 × 1015 | 25400 | 0.3% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| AGENTS | |
|---|---|
| LOT.COM | |
| ATO_CTO | 194883 |
| CALL CENTER | 122432 |
| LOT TRAVEL | 56342 |
Length
| Max length | 11 |
|---|---|
| Median length | 6 |
| Mean length | 6.39460726 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LOT TRAVEL |
|---|---|
| 2nd row | AGENTS |
| 3rd row | LOT.COM |
| 4th row | AGENTS |
| 5th row | AGENTS |
Common Values
| Value | Count | Frequency (%) |
| AGENTS | 6243016 | |
| LOT.COM | 2607855 | |
| ATO_CTO | 194883 | 2.1% |
| CALL CENTER | 122432 | 1.3% |
| LOT TRAVEL | 56342 | 0.6% |
| DCS | 59 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| agents | 6243016 | |
| lot.com | 2607855 | |
| ato_cto | 194883 | 2.1% |
| call | 122432 | 1.3% |
| center | 122432 | 1.3% |
| lot | 56342 | 0.6% |
| travel | 56342 | 0.6% |
| dcs | 59 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| ROUND TRIP | |
|---|---|
| ONE WAY | |
| MULTICITY |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 9.288865507 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ROUND TRIP |
|---|---|
| 2nd row | ROUND TRIP |
| 3rd row | ROUND TRIP |
| 4th row | ROUND TRIP |
| 5th row | ROUND TRIP |
Common Values
| Value | Count | Frequency (%) |
| ROUND TRIP | 6257485 | |
| ONE WAY | 1796410 | 19.5% |
| MULTICITY | 1170692 | 12.7% |
Length
Pie chart
| Value | Count | Frequency (%) |
| round | 6257485 | |
| trip | 6257485 | |
| one | 1796410 | 10.4% |
| way | 1796410 | 10.4% |
| multicity | 1170692 | 6.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 365 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 438 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 44.30218668 |
| Minimum | -1 |
|---|---|
| Maximum | 365 |
| Zeros | 166525 |
| Zeros (%) | 1.8% |
| Negative | 6569 |
| Negative (%) | 0.1% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 7 |
| median | 22 |
| Q3 | 58 |
| 95-th percentile | 168 |
| Maximum | 365 |
| Range | 366 |
| Interquartile range (IQR) | 51 |
Descriptive statistics
| Standard deviation | 56.14017749 |
|---|---|
| Coefficient of variation (CV) | 1.267210079 |
| Kurtosis | 4.990335168 |
| Mean | 44.30218668 |
| Median Absolute Deviation (MAD) | 17 |
| Skewness | 2.131762129 |
| Sum | 408649971 |
| Variance | 3151.719529 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 374643 | 4.1% |
| 7 | 309574 | 3.4% |
| 2 | 307512 | 3.3% |
| 5 | 305500 | 3.3% |
| 3 | 298851 | 3.2% |
| 4 | 293911 | 3.2% |
| 6 | 288406 | 3.1% |
| 8 | 224411 | 2.4% |
| 10 | 198027 | 2.1% |
| 11 | 187889 | 2.0% |
| Other values (355) | 6435425 |
| Value | Count | Frequency (%) |
| -1 | 6569 | 0.1% |
| 0 | 166525 | |
| 1 | 374643 | |
| 2 | 307512 | |
| 3 | 298851 | |
| 4 | 293911 | |
| 5 | 305500 | |
| 6 | 288406 | |
| 7 | 309574 | |
| 8 | 224411 |
| Value | Count | Frequency (%) |
| 365 | 35 | < 0.1% |
| 364 | 12 | < 0.1% |
| 361 | 131 | |
| 360 | 118 | |
| 359 | 175 | |
| 358 | 141 | |
| 357 | 236 | |
| 356 | 173 | |
| 355 | 131 | |
| 354 | 219 |
| Distinct | 367 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 424 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1937.802156 |
| Minimum | -9999 |
|---|---|
| Maximum | 366 |
| Zeros | 321065 |
| Zeros (%) | 3.5% |
| Negative | 1796410 |
| Negative (%) | 19.5% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | -9999 |
|---|---|
| 5-th percentile | -9999 |
| Q1 | 1 |
| median | 4 |
| Q3 | 9 |
| 95-th percentile | 33 |
| Maximum | 366 |
| Range | 10365 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 3964.422267 |
|---|---|
| Coefficient of variation (CV) | -2.045834377 |
| Kurtosis | 0.3764763633 |
| Mean | -1937.802156 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | -1.541520623 |
| Sum | -1.787460295 × 1010 |
| Variance | 15716643.91 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| -9999 | 1796410 | |
| 2 | 912232 | 9.9% |
| 3 | 911736 | 9.9% |
| 4 | 686238 | 7.4% |
| 1 | 595092 | 6.5% |
| 7 | 435882 | 4.7% |
| 5 | 421307 | 4.6% |
| 6 | 350153 | 3.8% |
| 0 | 321065 | 3.5% |
| 8 | 303715 | 3.3% |
| Other values (357) | 2490333 |
| Value | Count | Frequency (%) |
| -9999 | 1796410 | |
| 0 | 321065 | 3.5% |
| 1 | 595092 | 6.5% |
| 2 | 912232 | |
| 3 | 911736 | |
| 4 | 686238 | 7.4% |
| 5 | 421307 | 4.6% |
| 6 | 350153 | 3.8% |
| 7 | 435882 | 4.7% |
| 8 | 303715 | 3.3% |
| Value | Count | Frequency (%) |
| 366 | 6 | < 0.1% |
| 365 | 46 | |
| 364 | 7 | < 0.1% |
| 362 | 2 | < 0.1% |
| 361 | 4 | < 0.1% |
| 360 | 20 | < 0.1% |
| 359 | 18 | < 0.1% |
| 358 | 77 | |
| 357 | 14 | < 0.1% |
| 356 | 44 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 MiB |
| False | |
|---|---|
| True |
| Value | Count | Frequency (%) |
| False | 7243975 | |
| True | 1980612 | 21.5% |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 79.2 MiB |
| False | |
|---|---|
| True | 1181 |
| Value | Count | Frequency (%) |
| False | 9223406 | |
| True | 1181 | < 0.1% |
FLIGHT_COUPONS
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 155 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.950106059 |
| Minimum | 1 |
|---|---|
| Maximum | 315 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 4 |
| Q3 | 8 |
| 95-th percentile | 20 |
| Maximum | 315 |
| Range | 314 |
| Interquartile range (IQR) | 6 |
Descriptive statistics
| Standard deviation | 16.47474572 |
|---|---|
| Coefficient of variation (CV) | 2.072267413 |
| Kurtosis | 49.09842659 |
| Mean | 7.950106059 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 6.224773058 |
| Sum | 73336445 |
| Variance | 271.4172464 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4 | 2999775 | |
| 2 | 2559332 | |
| 8 | 1174648 | 12.7% |
| 1 | 460980 | 5.0% |
| 6 | 428625 | 4.6% |
| 12 | 385880 | 4.2% |
| 16 | 238396 | 2.6% |
| 3 | 205973 | 2.2% |
| 10 | 96752 | 1.0% |
| 20 | 87102 | 0.9% |
| Other values (145) | 587124 | 6.4% |
| Value | Count | Frequency (%) |
| 1 | 460980 | 5.0% |
| 2 | 2559332 | |
| 3 | 205973 | 2.2% |
| 4 | 2999775 | |
| 5 | 24073 | 0.3% |
| 6 | 428625 | 4.6% |
| 7 | 5114 | 0.1% |
| 8 | 1174648 | 12.7% |
| 9 | 28140 | 0.3% |
| 10 | 96752 | 1.0% |
| Value | Count | Frequency (%) |
| 315 | 189 | < 0.1% |
| 279 | 279 | < 0.1% |
| 268 | 201 | < 0.1% |
| 265 | 159 | < 0.1% |
| 248 | 248 | < 0.1% |
| 235 | 141 | < 0.1% |
| 232 | 232 | < 0.1% |
| 222 | 222 | < 0.1% |
| 220 | 220 | < 0.1% |
| 216 | 810 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.806591124 |
| Minimum | 1 |
|---|---|
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.458649842 |
|---|---|
| Coefficient of variation (CV) | 0.2538758416 |
| Kurtosis | 1.324028627 |
| Mean | 1.806591124 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -0.5650081206 |
| Sum | 16665057 |
| Variance | 0.2103596776 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 6972663 | |
| 1 | 2023111 | 21.9% |
| 3 | 219421 | 2.4% |
| 4 | 8941 | 0.1% |
| 5 | 311 | < 0.1% |
| 6 | 57 | < 0.1% |
| 7 | 34 | < 0.1% |
| 10 | 33 | < 0.1% |
| 8 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 1 | 2023111 | 21.9% |
| 2 | 6972663 | |
| 3 | 219421 | 2.4% |
| 4 | 8941 | 0.1% |
| 5 | 311 | < 0.1% |
| 6 | 57 | < 0.1% |
| 7 | 34 | < 0.1% |
| 8 | 16 | < 0.1% |
| 10 | 33 | < 0.1% |
| Value | Count | Frequency (%) |
| 10 | 33 | < 0.1% |
| 8 | 16 | < 0.1% |
| 7 | 34 | < 0.1% |
| 6 | 57 | < 0.1% |
| 5 | 311 | < 0.1% |
| 4 | 8941 | 0.1% |
| 3 | 219421 | 2.4% |
| 2 | 6972663 | |
| 1 | 2023111 | 21.9% |
| Distinct | 90 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.91961342 |
| Minimum | 1 |
|---|---|
| Maximum | 99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 140.8 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 8 |
| Maximum | 99 |
| Range | 98 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 6.056848711 |
|---|---|
| Coefficient of variation (CV) | 2.074537906 |
| Kurtosis | 45.7372056 |
| Mean | 2.91961342 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 6.115811801 |
| Sum | 26932228 |
| Variance | 36.68541631 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1 | 5034103 | |
| 2 | 2129340 | |
| 3 | 725200 | 7.9% |
| 4 | 514854 | 5.6% |
| 5 | 191594 | 2.1% |
| 6 | 105102 | 1.1% |
| 7 | 55056 | 0.6% |
| 8 | 47960 | 0.5% |
| 9 | 47758 | 0.5% |
| 30 | 18156 | 0.2% |
| Other values (80) | 355464 | 3.9% |
| Value | Count | Frequency (%) |
| 1 | 5034103 | |
| 2 | 2129340 | |
| 3 | 725200 | 7.9% |
| 4 | 514854 | 5.6% |
| 5 | 191594 | 2.1% |
| 6 | 105102 | 1.1% |
| 7 | 55056 | 0.6% |
| 8 | 47960 | 0.5% |
| 9 | 47758 | 0.5% |
| 10 | 16692 | 0.2% |
| Value | Count | Frequency (%) |
| 99 | 297 | |
| 98 | 98 | < 0.1% |
| 96 | 96 | < 0.1% |
| 92 | 279 | |
| 90 | 360 | |
| 89 | 89 | < 0.1% |
| 88 | 176 | |
| 86 | 258 | |
| 85 | 170 | |
| 83 | 166 |
| Distinct | 55794 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| XMK-OUO-XMK | 77197 |
|---|---|
| OUO-FBI-OUO | 72312 |
| OUO-UGK-OUO | 67890 |
| OUO-WXA-OUO | 66542 |
| LFN-OUO-LFN | 61912 |
| Other values (55789) |
Length
| Max length | 35 |
|---|---|
| Median length | 11 |
| Mean length | 14.47592906 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | OUO-WXA-OUO |
|---|---|
| 2nd row | OUO-RRS-OUO |
| 3rd row | HIX-OUO-HIX |
| 4th row | DZN-OUO-LPF-OUO-EVJ |
| 5th row | NTH-LFF-NTH |
Common Values
| Value | Count | Frequency (%) |
| XMK-OUO-XMK | 77197 | 0.8% |
| OUO-FBI-OUO | 72312 | 0.8% |
| OUO-UGK-OUO | 67890 | 0.7% |
| OUO-WXA-OUO | 66542 | 0.7% |
| LFN-OUO-LFN | 61912 | 0.7% |
| OUO-VWT-OUO | 55118 | 0.6% |
| FBI-OUO-FBI | 49108 | 0.5% |
| OUO-VIM-OUO | 43878 | 0.5% |
| OUO-VMX-OUO | 40511 | 0.4% |
| OUO-GMW-OUO | 37334 | 0.4% |
| Other values (55784) | 8652785 |
Length
| Value | Count | Frequency (%) |
| xmk-ouo-xmk | 77197 | 0.8% |
| ouo-fbi-ouo | 72312 | 0.8% |
| ouo-ugk-ouo | 67890 | 0.7% |
| ouo-wxa-ouo | 66542 | 0.7% |
| lfn-ouo-lfn | 61912 | 0.7% |
| ouo-vwt-ouo | 55118 | 0.6% |
| fbi-ouo-fbi | 49108 | 0.5% |
| ouo-vim-ouo | 43878 | 0.5% |
| ouo-vmx-ouo | 40511 | 0.4% |
| ouo-gmw-ouo | 37334 | 0.4% |
| Other values (55784) | 8652785 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 145 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| OUO | |
|---|---|
| LFF | 455128 |
| EIE | 278176 |
| HIX | 236747 |
| NTH | 217121 |
| Other values (140) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | OUO |
|---|---|
| 2nd row | OUO |
| 3rd row | HIX |
| 4th row | DZN |
| 5th row | NTH |
Common Values
| Value | Count | Frequency (%) |
| OUO | 1866644 | 20.2% |
| LFF | 455128 | 4.9% |
| EIE | 278176 | 3.0% |
| HIX | 236747 | 2.6% |
| NTH | 217121 | 2.4% |
| LFN | 212850 | 2.3% |
| CYE | 201002 | 2.2% |
| FBI | 195876 | 2.1% |
| XMK | 193526 | 2.1% |
| UGK | 182378 | 2.0% |
| Other values (135) | 5185139 |
Length
| Value | Count | Frequency (%) |
| ouo | 1866644 | 20.2% |
| lff | 455128 | 4.9% |
| eie | 278176 | 3.0% |
| hix | 236747 | 2.6% |
| nth | 217121 | 2.4% |
| lfn | 212850 | 2.3% |
| cye | 201002 | 2.2% |
| fbi | 195876 | 2.1% |
| xmk | 193526 | 2.1% |
| ugk | 182378 | 2.0% |
| Other values (135) | 5185139 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 3 |
| Missing (%) | < 0.1% |
| Memory size | 140.8 MiB |
| PL | |
|---|---|
| DE | |
| US | |
| UA | |
| EE | |
| Other values (46) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | PL |
|---|---|
| 2nd row | PL |
| 3rd row | US |
| 4th row | UA |
| 5th row | LT |
Common Values
| Value | Count | Frequency (%) |
| PL | 2901845 | |
| DE | 832391 | 9.0% |
| US | 591713 | 6.4% |
| UA | 468357 | 5.1% |
| EE | 455128 | 4.9% |
| SE | 249853 | 2.7% |
| LT | 244425 | 2.6% |
| NL | 216992 | 2.4% |
| IL | 212850 | 2.3% |
| FR | 206603 | 2.2% |
| Other values (41) | 2844427 |
Length
| Value | Count | Frequency (%) |
| pl | 2901845 | |
| de | 832391 | 9.0% |
| us | 591713 | 6.4% |
| ua | 468357 | 5.1% |
| ee | 455128 | 4.9% |
| se | 249853 | 2.7% |
| lt | 244425 | 2.6% |
| nl | 216992 | 2.4% |
| il | 212850 | 2.3% |
| fr | 206603 | 2.2% |
| Other values (41) | 2844427 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 83698 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 438 |
| Missing (%) | < 0.1% |
| Memory size | 140.8 MiB |
| 2007-08-03 02:05:00 | 1910 |
|---|---|
| 2007-07-15 17:50:00 | 1867 |
| 2007-07-09 02:05:00 | 1712 |
| 2007-06-28 02:05:00 | 1683 |
| 2007-04-30 02:05:00 | 1614 |
| Other values (83693) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1345 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2007-05-12 05:25:00 |
|---|---|
| 2nd row | 2007-08-26 11:55:00 |
| 3rd row | 2007-03-06 03:35:00 |
| 4th row | 2007-04-08 03:05:00 |
| 5th row | 2007-01-16 17:35:00 |
Common Values
| Value | Count | Frequency (%) |
| 2007-08-03 02:05:00 | 1910 | < 0.1% |
| 2007-07-15 17:50:00 | 1867 | < 0.1% |
| 2007-07-09 02:05:00 | 1712 | < 0.1% |
| 2007-06-28 02:05:00 | 1683 | < 0.1% |
| 2007-04-30 02:05:00 | 1614 | < 0.1% |
| 2007-07-21 02:05:00 | 1539 | < 0.1% |
| 2007-09-21 02:05:00 | 1513 | < 0.1% |
| 2007-07-05 02:05:00 | 1487 | < 0.1% |
| 2007-12-21 09:25:00 | 1479 | < 0.1% |
| 2007-07-13 08:25:00 | 1478 | < 0.1% |
| Other values (83688) | 9207867 |
Length
| Value | Count | Frequency (%) |
| 08:25:00 | 199168 | 1.1% |
| 02:05:00 | 176140 | 1.0% |
| 17:50:00 | 149657 | 0.8% |
| 12:55:00 | 147078 | 0.8% |
| 05:00:00 | 140003 | 0.8% |
| 05:30:00 | 124182 | 0.7% |
| 01:55:00 | 123850 | 0.7% |
| 08:45:00 | 119544 | 0.6% |
| 08:30:00 | 115082 | 0.6% |
| 05:20:00 | 106939 | 0.6% |
| Other values (1117) | 17046655 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 147 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1170692 |
| Missing (%) | 12.7% |
| Memory size | 140.8 MiB |
| OUO | |
|---|---|
| EIE | 298029 |
| LFF | 278498 |
| UGK | 202817 |
| WXA | 182412 |
| Other values (142) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | WXA |
|---|---|
| 2nd row | RRS |
| 3rd row | OUO |
| 4th row | LPF |
| 5th row | LFF |
Common Values
| Value | Count | Frequency (%) |
| OUO | 1257167 | 13.6% |
| EIE | 298029 | 3.2% |
| LFF | 278498 | 3.0% |
| UGK | 202817 | 2.2% |
| WXA | 182412 | 2.0% |
| FBI | 176627 | 1.9% |
| NTH | 175712 | 1.9% |
| GMW | 169386 | 1.8% |
| FOH | 168418 | 1.8% |
| LFN | 166213 | 1.8% |
| Other values (137) | 4978616 | |
| (Missing) | 1170692 | 12.7% |
Length
| Value | Count | Frequency (%) |
| ouo | 1257167 | 15.6% |
| eie | 298029 | 3.7% |
| lff | 278498 | 3.5% |
| ugk | 202817 | 2.5% |
| wxa | 182412 | 2.3% |
| fbi | 176627 | 2.2% |
| nth | 175712 | 2.2% |
| gmw | 169386 | 2.1% |
| foh | 168418 | 2.1% |
| lfn | 166213 | 2.1% |
| Other values (137) | 4978616 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 50 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 1170692 |
| Missing (%) | 12.7% |
| Memory size | 140.8 MiB |
| PL | |
|---|---|
| DE | |
| UA | |
| US | |
| EE | 278564 |
| Other values (45) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FR |
|---|---|
| 2nd row | CA |
| 3rd row | PL |
| 4th row | DE |
| 5th row | EE |
Common Values
| Value | Count | Frequency (%) |
| PL | 2214715 | |
| DE | 612387 | 6.6% |
| UA | 492939 | 5.3% |
| US | 405214 | 4.4% |
| EE | 278564 | 3.0% |
| FR | 240963 | 2.6% |
| NL | 212840 | 2.3% |
| RU | 202213 | 2.2% |
| LT | 200527 | 2.2% |
| GB | 179586 | 1.9% |
| Other values (40) | 3013947 | |
| (Missing) | 1170692 | 12.7% |
Length
| Value | Count | Frequency (%) |
| pl | 2214715 | |
| de | 612387 | 7.6% |
| ua | 492939 | 6.1% |
| us | 405214 | 5.0% |
| ee | 278564 | 3.5% |
| fr | 240963 | 3.0% |
| nl | 212840 | 2.6% |
| ru | 202213 | 2.5% |
| lt | 200527 | 2.5% |
| gb | 179586 | 2.2% |
| Other values (40) | 3013947 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 86418 |
|---|---|
| Distinct (%) | 0.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 140.8 MiB |
| 2008-01-03 18:05:00 | 1648 |
|---|---|
| 2008-01-06 18:05:00 | 1625 |
| 2007-09-09 00:10:00 | 1610 |
| 2007-11-04 18:05:00 | 1608 |
| 2007-09-01 00:10:00 | 1586 |
| Other values (86413) |
Length
| Max length | 19 |
|---|---|
| Median length | 19 |
| Mean length | 19 |
| Min length | 19 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1313 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2007-05-16 19:55:00 |
|---|---|
| 2nd row | 2007-09-16 10:40:00 |
| 3rd row | 2007-03-21 01:50:00 |
| 4th row | 2007-04-15 14:15:00 |
| 5th row | 2007-01-17 17:05:00 |
Common Values
| Value | Count | Frequency (%) |
| 2008-01-03 18:05:00 | 1648 | < 0.1% |
| 2008-01-06 18:05:00 | 1625 | < 0.1% |
| 2007-09-09 00:10:00 | 1610 | < 0.1% |
| 2007-11-04 18:05:00 | 1608 | < 0.1% |
| 2007-09-01 00:10:00 | 1586 | < 0.1% |
| 2008-01-02 18:05:00 | 1573 | < 0.1% |
| 2008-01-01 18:05:00 | 1543 | < 0.1% |
| 2007-12-30 18:05:00 | 1517 | < 0.1% |
| 2007-09-16 00:10:00 | 1495 | < 0.1% |
| 2008-01-04 18:05:00 | 1477 | < 0.1% |
| Other values (86408) | 9208905 |
Length
| Value | Count | Frequency (%) |
| 00:10:00 | 198492 | 1.1% |
| 19:40:00 | 180242 | 1.0% |
| 17:05:00 | 142496 | 0.8% |
| 14:15:00 | 132105 | 0.7% |
| 17:00:00 | 125269 | 0.7% |
| 16:55:00 | 122411 | 0.7% |
| 21:45:00 | 121380 | 0.7% |
| 16:50:00 | 120447 | 0.7% |
| 20:45:00 | 119926 | 0.7% |
| 20:55:00 | 118994 | 0.6% |
| Other values (1202) | 17067412 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.